-
Re: How do I pull the second name from a multiple-contact column?
I think I finally have it: =IFERROR(IF(COUNTM([Project Support]@row) = 2, RIGHT([Project Support]@row, LEN([Project Support]@row) - FIND(",", [Project Support]@row)), IF(COUNTM([Project Sup…1 · -
Re: Column Formula issue
Happy to help. I find it good practice to throw in an ISDATE() for validation anytime I'm working with dates. There are just too many ways dates can go wrong.1 · -
Re: What view are you? Share your story and claim your badge
The Gantt and Timeline views are super useful in specific scenarios, but I prefer Grid view (Old Faithful) the majority of the time.2 · -
Re: Add Months to Date formula?
@Ami Veltrie Give this a try: =IF(AND([Copper Report]@row = 1, [CR Frequency (Months)]@row = 3), DATE(IF(MONTH([CR Due Date]@row) >= 10, YEAR([CR Due Date]@row) + 1, YEAR([CR Due Date]@row)), IF(M…1 · -
Re: Meet Lauren Dominique, our June Member Spotlight! 🎉
Hartford Yard Goats This may very well be the best sports team name ever.2 ·